<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_users`;");
E_C("CREATE TABLE `ecs_users` (
  `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `aite_id` text NOT NULL,
  `email` varchar(60) NOT NULL DEFAULT '',
  `user_name` varchar(60) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `question` varchar(255) NOT NULL DEFAULT '',
  `answer` varchar(255) NOT NULL DEFAULT '',
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `birthday` date NOT NULL DEFAULT '0000-00-00',
  `user_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `frozen_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pay_points` int(10) unsigned NOT NULL DEFAULT '0',
  `rank_points` int(10) unsigned NOT NULL DEFAULT '0',
  `address_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `reg_time` int(10) unsigned NOT NULL DEFAULT '0',
  `last_login` int(11) unsigned NOT NULL DEFAULT '0',
  `last_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_ip` varchar(15) NOT NULL DEFAULT '',
  `visit_count` smallint(5) unsigned NOT NULL DEFAULT '0',
  `user_rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_special` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ec_salt` varchar(10) DEFAULT NULL,
  `salt` varchar(10) NOT NULL DEFAULT '0',
  `parent_id` mediumint(9) NOT NULL DEFAULT '0',
  `flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `alias` varchar(60) NOT NULL,
  `msn` varchar(60) NOT NULL,
  `qq` varchar(20) NOT NULL,
  `office_phone` varchar(20) NOT NULL,
  `home_phone` varchar(20) NOT NULL,
  `mobile_phone` varchar(20) NOT NULL,
  `is_validated` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `credit_line` decimal(10,2) unsigned NOT NULL,
  `passwd_question` varchar(50) DEFAULT NULL,
  `passwd_answer` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  KEY `email` (`email`),
  KEY `parent_id` (`parent_id`),
  KEY `flag` (`flag`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_users` values('1','','ecshop@ecshop.com','ecshop','554fcae493e564ee0dc75bdf2ebf94ca','','','0','1960-03-03','0.00','0.00','98388','15390','1','0','1245048540','0000-00-00 00:00:00','0.0.0.0','11','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('2','','vip@ecshop.com','vip','232059cb5361a9336ccf1b8c2ba7657a','','','0','1949-01-01','0.00','0.00','0','0','0','0','0','0000-00-00 00:00:00','','0','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('3','','text@ecshop.com','text','1cb251ec0d568de6a929b520c4aed8d1','','','0','1949-01-01','0.00','0.00','0','0','2','0','1242973574','0000-00-00 00:00:00','0.0.0.0','2','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('5','','zuanshi@ecshop.com','zuanshi','815a71fb334412e7ba4595741c5a111d','','','0','1949-01-01','0.00','10000.00','0','0','0','0','0','0000-00-00 00:00:00','','0','3','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('6','','admin123@qq.com','admin9041','79e4fb1ec5cb478cf37721d4fbcf4014','','','0','0000-00-00','0.00','0.00','10000000','0','3','1401218841','1403127354','0000-00-00 00:00:00','127.0.0.1','22','0','0','2330','0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('7','','zhouhuan@ecmoban.com','admin90412','0192023a7bbd73250516f069df18b500','','','0','0000-00-00','0.00','0.00','0','0','0','1403116746','1403116746','0000-00-00 00:00:00','127.0.0.1','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('8','','565296888@qq.com','zhu','ba84360575ec29bc579f1ae2993c02bc','','','0','0000-00-00','0.00','0.00','0','0','4','1411852764','1419808662','0000-00-00 00:00:00','127.0.0.1','38','0','0','8495','0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('9','','565296844@qq.com','dddd','96e79218965eb72c92a549dd5a330112','','','0','0000-00-00','0.00','0.00','0','0','0','1418170568','1418170569','0000-00-00 00:00:00','127.0.0.1','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('10','','12345687@qq.com','光头强','f71c757f2ebeb51642dc1633afa81779','','','1','1954-01-01','99999644.09','100.00','420062','800000063','5','1419793467','1419803530','0000-00-00 00:00:00','192.168.1.103','5','0','0','5737','0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('11','','644194883@qq.com','ceshi01','1fccb567a44880e8665b7cb9d0f97271','','','0','0000-00-00','0.00','0.00','0','0','0','1439527481','1439527482','0000-00-00 00:00:00','127.0.0.1','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('12','','001@qq.com','ceshi','1fccb567a44880e8665b7cb9d0f97271','','','0','0000-00-00','0.00','0.00','0','0','0','1439530381','1439530381','0000-00-00 00:00:00','127.0.0.1','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL);");
E_D("replace into `ecs_users` values('13','','00001@qq.com','woshiguanliyuan','1fccb567a44880e8665b7cb9d0f97271','','','0','0000-00-00','0.00','0.00','0','0','0','1446969738','1446969738','0000-00-00 00:00:00','127.0.0.1','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL);");

require("../../inc/footer.php");
?>